﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using cmsservice.Entity;
using System.Data;

namespace cmsservice.DAL
{
    public class SecurityDAL
    {
        public List<Security> GetAll()
        {
            string sql = "select * from [Security] where [SecuCategory] in ('001001','001002') and ListState<>'013002'";
            return SqlHelper.GetDataByColumnsLst<Security>(DBConn.NewDMSConnstr, sql, null);
        }
        public List<Security> GetAllStocks()
        {
            string sql = "select * from [Security] where [SecuCategory] in ('001001','001002') and ListState<>'013002'";
            return SqlHelper.GetDataByColumnsLst<Security>(DBConn.NewDMSConnstr, sql, null);
        }
    }
}
